CREATE TABLE [dbo].[gemiddelde] (
	[volgnr] [bigint] IDENTITY (1, 1) NOT NULL ,
	[jaar] [char] (4) NULL ,
	[klas] [char] (5) NULL ,
	[vakcode] [char] (2) NULL ,
	[gem_dw1] [int] NULL ,
	[gem_ex1] [int] NULL ,
	[gem_tot1] [int] NULL ,
	[gem_dw2] [int] NULL ,
	[gem_ex2] [int] NULL ,
	[gem_tot2] [int] NULL ,
	[gem_dw3] [int] NULL ,
	[gem_ex3] [int] NULL ,
	[gem_tot3] [int] NULL ,
	[gem_dw4] [int] NULL ,
	[gem_ex4] [int] NULL ,
	[gem_tot4] [int] NULL ,
	[lk_ident] [char] (4) NULL ,
	CONSTRAINT [pk_gemiddelde] PRIMARY KEY  CLUSTERED 
	(
		[volgnr]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] ,
	 UNIQUE  NONCLUSTERED 
	(
		[volgnr]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]